package com.xonm.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBHelper extends SQLiteOpenHelper{

	public DBHelper(Context context,String dbName,int version) {
		super(context, dbName, null, version);
	}


	public void onCreate(SQLiteDatabase db) {
		
		String table_domain = "create table a_info(" +
				"_id INTEGER PRIMARY KEY AUTOINCREMENT," +
				"project TEXT," +
				"host TEXT," +
				"person TEXT," +
				"p_hp TEXT," +
				"a_yn INTEGER," +
				"s_yn INTEGER," +
				"f_yn INTEGER," +
				"regi_date TEXT" +
				");";
		db.execSQL(table_domain);		
	}


	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		db.execSQL("DROP TABLE IF EXISTS a_info");
		onCreate(db);
	}

}
